IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'RecommendationInsert')
	BEGIN
		DROP  Procedure  RecommendationInsert
	END

GO

CREATE Procedure RecommendationInsert
(
	@CompanyID int
	, @RatingTypeID int
	, @RecommendationDate smalldatetime
	, @Rating int
	, @Price smallmoney
)
AS

INSERT INTO Recommendations
(
	CompanyID
	, RatingTypeID
	, RecommendationDate
	, Rating
	, Price
)
VALUES
(
	@CompanyID
	, @RatingTypeID
	, @RecommendationDate
	, @Rating
	, @Price
)